﻿<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="WebForm6.aspx.vb" Inherits="PMS_Linq.WebForm6" %>

<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Charting" tagprefix="telerik" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        <table class="style1">
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    <asp:LinqDataSource ID="LinqDataSource1" runat="server" 
                        ContextTypeName="PMS_Linq.hc_databaseDataContext" EnableUpdate="True" 
                        TableName="mitgliede_anwaerter" EnableDelete="True" EnableInsert="True">
                        <UpdateParameters>
                            <asp:Parameter Name="Vorname" Type="String" />
                            <asp:Parameter Name="Nachname" Type="String" />
                            <asp:Parameter Name="Email_HC" Type="String" />
                            <asp:Parameter Name="telefon" Type="String" />
                            <asp:Parameter Name="Strasse_hausnr" Type="String" />
                            <asp:Parameter Name="Ort" Type="String" />
                            <asp:Parameter DbType="Date" Name="letzter_aktiv_check" />
                            <asp:Parameter Name="Aktiv_passiv" Type="Boolean" />
                            <asp:Parameter Name="E_Mail_privat" Type="String" />
                            <asp:Parameter Name="Mitgliedsstatus" Type="String" />
                            <asp:Parameter Name="Skype" Type="String" />
                            <asp:Parameter Name="Foto" Type="Object" />
                            <asp:Parameter Name="Studiengang" Type="String" />
                            <asp:Parameter Name="Semester" Type="Int32" />
                            <asp:Parameter Name="Vertiefung1" Type="String" />
                            <asp:Parameter Name="Vertiefung2" Type="String" />
                            <asp:Parameter Name="Vertiefung3" Type="String" />
                            <asp:Parameter Name="Vertiefung4" Type="String" />
                            <asp:Parameter Name="Ausbildung" Type="String" />
                            <asp:Parameter Name="Ressort" Type="String" />
                            <asp:Parameter DbType="Date" Name="ErsterHcAbend" />
                            <asp:Parameter DbType="Date" Name="ZielgespraechAP" />
                            <asp:Parameter DbType="Date" Name="Mitgliedsausfnahmegespraech" />
                            <asp:Parameter DbType="Date" Name="ZielgespraechJPM" />
                            <asp:Parameter Name="Aussenauftritt" Type="Boolean" />
                            <asp:Parameter DbType="Date" Name="PmAufnahmeGespraech" />
                            <asp:Parameter Name="original_ID" Type="Int32" />
                            <asp:Parameter Name="original_Vorname" Type="String" />
                            <asp:Parameter Name="original_Nachname" Type="String" />
                            <asp:Parameter Name="original_Email_HC" Type="String" />
                            <asp:Parameter Name="original_telefon" Type="String" />
                            <asp:Parameter Name="original_Strasse_hausnr" Type="String" />
                            <asp:Parameter Name="original_Ort" Type="String" />
                            <asp:Parameter DbType="Date" Name="original_letzter_aktiv_check" />
                            <asp:Parameter Name="original_Aktiv_passiv" Type="Boolean" />
                            <asp:Parameter Name="original_E_Mail_privat" Type="String" />
                            <asp:Parameter Name="original_Mitgliedsstatus" Type="String" />
                            <asp:Parameter Name="original_Skype" Type="String" />
                            <asp:Parameter Name="original_Foto" Type="Object" />
                            <asp:Parameter Name="original_Studiengang" Type="String" />
                            <asp:Parameter Name="original_Semester" Type="Int32" />
                            <asp:Parameter Name="original_Vertiefung1" Type="String" />
                            <asp:Parameter Name="original_Vertiefung2" Type="String" />
                            <asp:Parameter Name="original_Vertiefung3" Type="String" />
                            <asp:Parameter Name="original_Vertiefung4" Type="String" />
                            <asp:Parameter Name="original_Ausbildung" Type="String" />
                            <asp:Parameter Name="original_Ressort" Type="String" />
                            <asp:Parameter DbType="Date" Name="original_ErsterHcAbend" />
                            <asp:Parameter DbType="Date" Name="original_ZielgespraechAP" />
                            <asp:Parameter DbType="Date" Name="original_Mitgliedsausfnahmegespraech" />
                            <asp:Parameter DbType="Date" Name="original_ZielgespraechJPM" />
                            <asp:Parameter Name="original_Aussenauftritt" Type="Boolean" />
                            <asp:Parameter DbType="Date" Name="original_PmAufnahmeGespraech" />
                        </UpdateParameters>                                                
                    </asp:LinqDataSource>
                </td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    <telerik:RadChart ID="RadChart1" runat="server" DataSourceID="SqlDataSource7" 
                        Skin="Blue" Width="800px">
                        <Series>
                            <telerik:ChartSeries DataXColumn="Projektschritt" DataYColumn="Ist" Name="Ist">
                                <Appearance>
                                    <FillStyle MainColor="222, 245, 245" SecondColor="222, 245, 245">
                                    </FillStyle>
                                    <EmptyValue Mode="Zero">
                                    </EmptyValue>
                                    <Border Color="DimGray" />
                                </Appearance>
                            </telerik:ChartSeries>
                            <telerik:ChartSeries DataXColumn="Projektschritt" DataYColumn="Soll" 
                                Name="Soll">
                                <Appearance>
                                    <FillStyle MainColor="140, 198, 220" SecondColor="140, 198, 220">
                                    </FillStyle>
                                    <EmptyValue Mode="Zero">
                                    </EmptyValue>
                                    <Border Color="DimGray" />
                                </Appearance>
                            </telerik:ChartSeries>
                        </Series>
                        <Legend>
                            <Appearance>
                                <ItemTextAppearance TextProperties-Color="DimGray">
                                </ItemTextAppearance>
                                <Border Color="DimGray" />
                            </Appearance>
                        </Legend>
                        <PlotArea>
                            <XAxis AutoScale="False" DataLabelsColumn="Bezeichnung" MaxValue="7" 
                                MinValue="1" Step="1">
                                <Appearance>
                                    <MajorGridLines Color="DimGray" Width="0" />
                                </Appearance>
                                <AxisLabel>
                                    <TextBlock>
                                        <Appearance TextProperties-Font="Verdana, 9.75pt, style=Bold">
                                        </Appearance>
                                    </TextBlock>
                                </AxisLabel>
                                <Items>
                                    <telerik:ChartAxisItem Value="1">
                                        <TextBlock Text="abc">
                                        </TextBlock>
                                    </telerik:ChartAxisItem>
                                    <telerik:ChartAxisItem Value="2">
                                        <TextBlock Text="abc">
                                        </TextBlock>
                                    </telerik:ChartAxisItem>
                                    <telerik:ChartAxisItem Value="3">
                                        <TextBlock Text="abc">
                                        </TextBlock>
                                    </telerik:ChartAxisItem>
                                    <telerik:ChartAxisItem Value="4">
                                        <TextBlock Text="abc">
                                        </TextBlock>
                                    </telerik:ChartAxisItem>
                                    <telerik:ChartAxisItem Value="5">
                                        <TextBlock Text="abc">
                                        </TextBlock>
                                    </telerik:ChartAxisItem>
                                    <telerik:ChartAxisItem Value="6">
                                        <TextBlock Text="abc">
                                        </TextBlock>
                                    </telerik:ChartAxisItem>
                                    <telerik:ChartAxisItem Value="7">
                                        <TextBlock Text="abc">
                                        </TextBlock>
                                    </telerik:ChartAxisItem>
                                </Items>
                            </XAxis>
                            <YAxis>
                                <Appearance>
                                    <MajorGridLines Color="DimGray" />
                                </Appearance>
                                <AxisLabel>
                                    <TextBlock>
                                        <Appearance TextProperties-Font="Verdana, 9.75pt, style=Bold">
                                        </Appearance>
                                    </TextBlock>
                                </AxisLabel>
                            </YAxis>
                            <YAxis2>
                                <AxisLabel>
                                    <TextBlock>
                                        <Appearance TextProperties-Font="Verdana, 9.75pt, style=Bold">
                                        </Appearance>
                                    </TextBlock>
                                </AxisLabel>
                            </YAxis2>
                            <Appearance Corners="Round, Round, Round, Round, 6">
                                <FillStyle FillType="Solid" MainColor="White">
                                </FillStyle>
                                <Border Color="DimGray" />
                            </Appearance>
                        </PlotArea>
                        <ChartTitle>
                            <Appearance Corners="Round, Round, Round, Round, 6" 
                                Dimensions-Margins="4%, 10px, 14px, 0%" Position-AlignedPosition="Top">
                                <FillStyle GammaCorrection="False" MainColor="224, 224, 224">
                                </FillStyle>
                                <Border Color="DimGray" />
                            </Appearance>
                            <TextBlock Text="Projektstand">
                                <Appearance TextProperties-Font="Verdana, 11.25pt">
                                </Appearance>
                            </TextBlock>
                        </ChartTitle>
                    </telerik:RadChart>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:PMSConnectionString %>" 
                        SelectCommand="SELECT Phase.Bezeichnung, Phase.Projektschritt, SUM(report.Dauer) / 8 AS Ist, Phase.Dauer / 8 AS Soll FROM Phase INNER JOIN report ON Phase.Id = report.PhasenID WHERE (Phase.Projekt_ID = @ID) GROUP BY Phase.Projektschritt, Phase.Bezeichnung, Phase.Dauer ORDER BY Phase.Projektschritt">
                        <SelectParameters>
                            <asp:QueryStringParameter Name="ID" QueryStringField="name" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                </td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
        </table>
    
    </div>
    </form>
</body>
</html>
